using System;
using System.Data;
using System.Data.SqlClient;

public class <OwnerU>_<TableU>DataClass
{
    internal static SqlDataAdapter da = new SqlDataAdapter();

    public static string SelectAll()
    {
        return "SELECT "  
            <Loop>
            + "    <SF[,]>[<FieldC>] = [<Field>] "
            </Loop>
            + "FROM " 
            + "     [<Owner>].[<Table>] "
            + "";
    }

    public static DataTable Open()
    {
        SqlConnection con = <Database>DataClass.GetConnection();
        DataTable dt = new DataTable();
        da.SelectCommand = new SqlCommand(SelectAll(), con);
        da.SelectCommand.CommandType = CommandType.Text;
        SqlCommandBuilder builder = new SqlCommandBuilder(da);
        con.Open();
        da.Fill(dt);
        return dt;
    }

    public void Save(System.Windows.Forms.DataGridView grid)
    {
        try
        {
            dynamic dt = (DataTable)grid.DataSource;
            da.Update(dt);
            grid.EndEdit();
        }
        catch
        {
        }
    }

}

